package com.zhejiangzhengyuan.municipal_common.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zhejiangzhengyuan.municipal_common.entity.SubsidiaryFacilitiesGis;
import com.zhejiangzhengyuan.municipal_common.entity.vo.SubsidiaryFacilitiesGisVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * GIS数据库中附属设施表 Mapper 接口
 *
 * @author linju
 * @since 2020-01-13
 */
@Repository
public interface SubsidiaryFacilitiesGisMapper extends BaseMapper<SubsidiaryFacilitiesGis> {

  @Select("select * from Subsidiary_facilities_gis")
  Page<SubsidiaryFacilitiesGisVo> selectAllSubsidiaryFacilitiesGis(
      Page<SubsidiaryFacilitiesGisVo> subsidiaryFacilitiesGisPage);

  Page<SubsidiaryFacilitiesGisVo> FuzzySubsidiaryFacilitiesGis(
      Page<SubsidiaryFacilitiesGisVo> subsidiaryFacilitiesGisVoPage,
      @Param("sName") String sName,
      @Param("sCode") String sCode);
}
